package com.xsr.mapper;

import com.xsr.pojo.Profile;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * @author 邢式瑞
 * @version 1.0
 * @project peopleThing
 * @date 2022/9/11 19:01
 */
public interface ProfileMapper {
@Select("select id,name,birthday,gender,career,address,mobile,picture from profile")
    List<Profile> selectAll() ;
@Select("select name,birthday,gender,career,address,mobile,picture from profile where id=#{id}")
    Profile selectById(Integer id);
@Update(" update  profile  set name=#{name} ,birthday=#{birthday},career=#{career},address=#{address},mobile=#{mobile},picture=#{picture} where id=#{id}")
    void update(Profile profile);
}
